Re: pg_restore error

>Are you sure the synd_article table and cable_id_cable_seq sequence aren't
>already in the database?

yes, there are existing.

>Presumably your dump file contains the create statements for these two
>objects and so the pg_restore is trying to create them.
>
>How did you create the dump file? The -a switch will allow you to dump only
>the data if that's what you need. Looks like you may be dumping the schema
>as well

I tried with the -a option, and it was quite the same.
I just tried to delete the synd_article_pkey  then restore the table
synd_article, but it didn't recreate the keys as they were. and i
don't know how to do that (as i am using mysql for my other projects
and that it seams to be more simple).


thanks,
pascal.

>HTH
>
>adam
>
>>  hello everybody,
>>
>>  i am pascal, i am from paris, france, and i am a newbie here.
>>  well, i have a problem with the pg_restore command and i don't find
>>  any informations on the web about it. when trying to restaure a
>>  database, i have the above error :
>>
>>  [postgres@preprod2 pgsql]$ bin/pg_restore -d interlig -Fc
>>  /home/postgres/dump_20021010new.out
>>  pg_restore: [archiver (db)] could not execute query: ERROR:  Relation
>>  'cable_id_cable_seq' already exists
>>
>>  and i try this :
>>
>>  [postgres@preprod2 pgsql]$ bin/pg_restore -d interlig -Fc
>>  /home/postgres/dump_20021010new.out -t synd_article
>>  pg_restore: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit
>  > index '' for table 'synd_article'
>>  pg_restore: [archiver (db)] could not execute query: ERROR:  Relation
>>  'synd_article' already exists
>>
>>
>>  I don't understand what can be this error, i just want to restore my
>  > database as the same it was a few hours ago.
>  >
>  > thank you for your help,
>  >
>  > pascal.


--


http://www.magnetophone.com